package com.qckj.amz.domain;

import com.fasterxml.jackson.annotation.JsonFormat;
import com.qckj.common.annotation.Excel;
import com.qckj.common.core.domain.BaseEntity;
import lombok.Data;

import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 产品基础信息对象 t_product_temp_basic
 *
 * @author luchuan
 * @since 1.0 2021-12-20
 */
@Entity
@Table(name = "t_product_temp_basic")
@Data
public class ProductTempBasic extends BaseEntity {

    private static final long serialVersionUID = 1L;

    /** 主键自增 */
    @Excel(name = "操作序号", cellType = Excel.ColumnType.NUMERIC)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Id
    @Column(name="id")
    private Long id;

    /** 产品代码 */
    @Excel(name = "产品代码")
    @Column(name="product_code")
    private String productCode;

    /** 批次号 */
    @Column(name="batch_no")
    private String batchNo;

    /** 产品分类 */
    @Excel(name = "产品分类")
    @Column(name="product_category")
    private String productCategory;

    /** 价格系数 */
    @Column(name="standard_price_coefficient")
    private BigDecimal standardPriceCoefficient;

    /** 产品来源 */
    @Excel(name = "产品来源")
    @Column(name="product_source_type")
    private String productSourceType;

    /** 采购链接 */
    @Column(name="buying_link")
    private String buyingLink;

    /** 采购价格 */
    @Column(name="buying_price")
    private BigDecimal buyingPrice;

    /** 产品共享 */
    @Excel(name = "产品共享")
    @Column(name="product_sharing_type")
    private String productSharingType;

    /** 是否佣金 */
    @Column(name="is_commission_type")
    private String isCommissionType;

    /** 佣金率 */
    @Column(name="commission_rate")
    private BigDecimal commissionRate;

    /** 产品状态 */
    @Excel(name = "产品状态")
    @Column(name="product_status")
    private String productStatus;

    /** 是否暂存 */
    @Excel(name = "是否暂存")
    @Column(name="is_staging")
    private String isStaging;

    /** 主图 */
    @Excel(name = "主图")
    @Column(name="main_image_url")
    private String mainImageUrl;

    /** 长度 */
    @Excel(name = "长度")
    @Column(name="length")
    private BigDecimal length;

    /** 宽度 */
    @Excel(name = "宽度")
    @Column(name="width")
    private BigDecimal width;

    /** 高度 */
    @Excel(name = "高度")
    @Column(name="height")
    private BigDecimal height;

    /** 重量 */
    @Excel(name = "重量")
    @Column(name="weight")
    private BigDecimal weight;

    /** 材料 */
    @Excel(name = "材料")
    @Column(name="material")
    private String material;

    /** 产品特殊性质 */
    @Excel(name = "产品特殊性质")
    @Column(name="special_type")
    private String specialType;

    /** 认领次数 */
    @Excel(name = "认领次数")
    @Column(name="claim_num")
    private int claimNum;

    /** 创建人 */
    @Excel(name = "创建人")
    @Column(name="create_by")
    private String createBy;

    /** 创建时间 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Column(name="create_time")
    private Date createTime;

    /** 更新人 */
    @Column(name="update_by")
    private String updateBy;

    /** 更新时间 */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @Excel(name = "更新时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss")
    @Column(name="update_time")
    private Date updateTime;

    /** 备注 */
    @Excel(name = "备注")
    @Column(name="remark")
    private String remark;


}
